1: Go to your CS:S installation directory, ussually C:\Program Files\Steam\steamapps\[account-name]\counter-strike source\
2: Extract the "maps" folder to here*
3: Start CS:S and you should be able to start play the new map.

* If the custom textures used for the map won't show up in-game, extract the "materials" folder here too.